﻿CREATE TABLE [dbo].[Hierarchy]
(
	HIE_HierarchyID INT IDENTITY(1,1) NOT NULL,
	HIE_ParentHierarchyID INT NULL,
	HIE_Name NVARCHAR(50) NOT NULL,
	HIE_Description NVARCHAR(256) NULL,
	HIE_LastModifiedBy NVARCHAR(100) NOT NULL,
	HIE_LastModifiedDate DATETIME NOT NULL
)
